package com.cn.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface DownloadDao {
	@Insert("insert into downloadinfo(file,user) value(#{file},#{user})")
	void insertInfo(@Param("file") Integer file,@Param("user") Integer user);
	@Select("select fileinfo.*,userinfo.* from downloadinfo inner join fileinfo on downloadinfo.file=fileinfo.id inner join userinfo on userinfo.id=downloadinfo.user")
	List<Map<String,Object>> detail();
}
